### How to Set Up MySQL Database with Docker (Using Docker Command and Docker-Compose)
Setting up a MySQL database using Docker simplifies the process of database management, allowing you to create, configure, and manage your databases in isolated containers. This guide will walk you through the steps to set up a MySQL database using Docker commands and Docker-Compose.
**Requirements:**
- Docker installed on your system
- Basic knowledge of command-line interface
**Step-by-Step Guide:**
## Using Docker Command
### Step 1: Pull the MySQL Docker Image
First, you need to pull the official MySQL image from the Docker Hub repository.
```bash
docker pull mysql:latest
```
### Step 2: Run a MySQL Container
Run a container using the MySQL image with environment variables for the root password and other configurations.
```bash
docker run --name mysql-container -e MYSQL_ROOT_PASSWORD=rootpassword -e MYSQL_DATABASE=mydatabase -e MYSQL_USER=myuser -e MYSQL_PASSWORD=mypassword -p 3306:3306 -d mysql:latest
```
- `--name mysql-container`: Names the container `mysql-container`.
- `-e MYSQL_ROOT_PASSWORD=rootpassword`: Sets the root password.
- `-e MYSQL_DATABASE=mydatabase`: Creates a database named `mydatabase`.
- `-e MYSQL_USER=myuser`: Creates a user named `myuser`.
- `-e MYSQL_PASSWORD=mypassword`: Sets the password for `myuser`.
- `-p 3306:3306`: Maps port 3306 of the container to port 3306 of the host.
- `-d`: Runs the container in detached mode.
- `mysql:latest`: Uses the l
|
2024/06/27
youtube
